package org.example.jdbc;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Scanner;

/**
 * 登录功能
 */
public class bac {
    public static void main(String[] args) {
        try (Connection connection=DBUtil.getConnection();){
            Statement statement=connection.createStatement();
            //接收用户输入
            Scanner scanner=new Scanner(System.in);
            System.out.println("请输入用户名：");
            String username=scanner.nextLine();
            System.out.println("请输入密码");
            String password=scanner.nextLine();
            //执行SQL语句
            ResultSet resultSet = statement.executeQuery("SELECT nickname FROM user WHERE" +
                    " username='"+username+"' AND password='"+password+"'");
            if(resultSet.next()){
                String nickname=resultSet.getString("nickname");
                System.out.println(nickname);
            }else{
                System.out.println("错误");
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}
